<?php
namespace app\admin\controller;

use think\Controller;
use think\Request;
use think\Db;
use think\Log;

class Layui extends Controller
{

    public function index()
    {
        return view();
    }
    //一共利用了selctList是表格列表只需要进行对应的table 字段的改变即可
    //删除/编辑/查看/添加
    //都是基于一个demo 
    
    // 表格数据的展示使用layui-table即可
    // 编辑查看删除 单独的进行detail edit delete
    // add layui-form
    // 即可
    // 查看详细信息使用弹窗
    // 删除使用模态框
    // 编辑使用异步的方式
    // 添加使用模态框中的嵌入表单式
    // 分页使用layui
    //这里用了layui-table layer layui的弹窗 layui的模板引擎 amazeui的列表
    //ul-list
    public function add()
    {
      //return view();
    $value=input('get.value');
    $field=input('get.field');
    
    $arr=explode(',', $value);
    $arr2=explode(',', $field);
    
    $data= array_combine($arr2, $arr);
   $id= db('user')->insertGetID($data);
   if($id){
       ajaxReturn(1,'insert sucess','');
   }else {
       ajaxReturn(0,'insert failed','');
   }
    }
    public function delete()
    {
        try {
            $id=empty(input('get.id'))?ajaxReturn(-1,'id is miss',''):input('get.id');
            $res=db('user')->delete($id);
            if($res){
                ajaxReturn(1,'delete sucess','');
            }else {
                ajaxReturn(0,'delete faled',$id);
            }
        }catch (\think\Exception $e){
            Log::write('delete failed'.$e->getMessage());
        }
    }

    public function edit()
    {
       if(Request::instance()->isGet())
       {
          $field=input('get.field');
          $value=input('get.value');
          $id=input('get.id');
         if(empty($field)){
             ajaxReturn(-1,'parame is miss','');
         }
         if(empty($value)){
             ajaxReturn(-1,'parame is miss','');
         }
        if(empty($id)){
            ajaxReturn(-1,'parame is miss','');
        }
       $res=db('user')->where('id',$id)->setField($field,$value);
       if($res){
           ajaxReturn(1,'edit sucess','');
       }else {
            ajaxReturn(0,'edit failed',$res);
       }
       }
    }

    public function selectLists()
    {
      //这里默认返回的正确格式是 code=0;记住了
      //如果想要自定义的request的定义page limit 即可
      //response 的自定义的定义即可
        
            try 
            {
                $page=empty(input('get.page'))?1:input('get.page');
                $limit=empty(input('get.limit'))?10:input('get.limit');
                $res= Db::table('zx_user')->page($page,$limit)->select();
                $count=db('user')->count('id');
               if(empty($res))
               {
                 $result['code']=201;
                 $result['msg']='fetch failed';
                 $result['count']='';
                 $result['data']='';
                 return $result;
               }else {
                   $result['code']=0;
                   $result['msg']='ok';
                   $result['count']=$count;
                   $result['data']=$res;
                   echo json_encode($result);
               }
            }catch (\think\Exception $e){
                Log::write('exception'.$e->getMessage());
            }
         
        
    }

    public function selectItem()
    {
        
    }

    public function aj_upload()
    
    {
        
    }

    public function sever_upload()
    {
        
    }

    public function auto()
    {
        
    }
    public function show()
    {
        return view();
    }
    public function ce()
    {
        $str='{"code":0,"msg":"","count":1000,"data":[{"id":10000,"username":"user-0","sex":"女","city":"城市-0","sign":"签名-0","experience":255,"logins":24,"wealth":82830700,"classify":"作家","score":57},{"id":10001,"username":"user-1","sex":"男","city":"城市-1","sign":"签名-1","experience":884,"logins":58,"wealth":64928690,"classify":"词人","score":27},{"id":10002,"username":"user-2","sex":"女","city":"城市-2","sign":"签名-2","experience":650,"logins":77,"wealth":6298078,"classify":"酱油","score":31},{"id":10003,"username":"user-3","sex":"女","city":"城市-3","sign":"签名-3","experience":362,"logins":157,"wealth":37117017,"classify":"诗人","score":68},{"id":10004,"username":"user-4","sex":"男","city":"城市-4","sign":"签名-4","experience":807,"logins":51,"wealth":76263262,"classify":"作家","score":6},{"id":10005,"username":"user-5","sex":"女","city":"城市-5","sign":"签名-5","experience":173,"logins":68,"wealth":60344147,"classify":"作家","score":87},{"id":10006,"username":"user-6","sex":"女","city":"城市-6","sign":"签名-6","experience":982,"logins":37,"wealth":57768166,"classify":"作家","score":34},{"id":10007,"username":"user-7","sex":"男","city":"城市-7","sign":"签名-7","experience":727,"logins":150,"wealth":82030578,"classify":"作家","score":28},{"id":10008,"username":"user-8","sex":"男","city":"城市-8","sign":"签名-8","experience":951,"logins":133,"wealth":16503371,"classify":"词人","score":14},{"id":10009,"username":"user-9","sex":"女","city":"城市-9","sign":"签名-9","experience":484,"logins":25,"wealth":86801934,"classify":"词人","score":75},{"id":10010,"username":"user-10","sex":"女","city":"城市-10","sign":"签名-10","experience":1016,"logins":182,"wealth":71294671,"classify":"诗人","score":34},{"id":10011,"username":"user-11","sex":"女","city":"城市-11","sign":"签名-11","experience":492,"logins":107,"wealth":8062783,"classify":"诗人","score":6},{"id":10012,"username":"user-12","sex":"女","city":"城市-12","sign":"签名-12","experience":106,"logins":176,"wealth":42622704,"classify":"词人","score":54},{"id":10013,"username":"user-13","sex":"男","city":"城市-13","sign":"签名-13","experience":1047,"logins":94,"wealth":59508583,"classify":"诗人","score":63},{"id":10014,"username":"user-14","sex":"男","city":"城市-14","sign":"签名-14","experience":873,"logins":116,"wealth":72549912,"classify":"词人","score":8},{"id":10015,"username":"user-15","sex":"女","city":"城市-15","sign":"签名-15","experience":1068,"logins":27,"wealth":52737025,"classify":"作家","score":28},{"id":10016,"username":"user-16","sex":"女","city":"城市-16","sign":"签名-16","experience":862,"logins":168,"wealth":37069775,"classify":"酱油","score":86},{"id":10017,"username":"user-17","sex":"女","city":"城市-17","sign":"签名-17","experience":1060,"logins":187,"wealth":66099525,"classify":"作家","score":69},{"id":10018,"username":"user-18","sex":"女","city":"城市-18","sign":"签名-18","experience":866,"logins":88,"wealth":81722326,"classify":"词人","score":74},{"id":10019,"username":"user-19","sex":"女","city":"城市-19","sign":"签名-19","experience":682,"logins":106,"wealth":68647362,"classify":"词人","score":51},{"id":10020,"username":"user-20","sex":"男","city":"城市-20","sign":"签名-20","experience":770,"logins":24,"wealth":92420248,"classify":"诗人","score":87},{"id":10021,"username":"user-21","sex":"男","city":"城市-21","sign":"签名-21","experience":184,"logins":131,"wealth":71566045,"classify":"词人","score":99},{"id":10022,"username":"user-22","sex":"男","city":"城市-22","sign":"签名-22","experience":739,"logins":152,"wealth":60907929,"classify":"作家","score":18},{"id":10023,"username":"user-23","sex":"女","city":"城市-23","sign":"签名-23","experience":127,"logins":82,"wealth":14765943,"classify":"作家","score":30},{"id":10024,"username":"user-24","sex":"女","city":"城市-24","sign":"签名-24","experience":212,"logins":133,"wealth":59011052,"classify":"词人","score":76},{"id":10025,"username":"user-25","sex":"女","city":"城市-25","sign":"签名-25","experience":938,"logins":182,"wealth":91183097,"classify":"作家","score":69},{"id":10026,"username":"user-26","sex":"男","city":"城市-26","sign":"签名-26","experience":978,"logins":7,"wealth":48008413,"classify":"作家","score":65},{"id":10027,"username":"user-27","sex":"女","city":"城市-27","sign":"签名-27","experience":371,"logins":44,"wealth":64419691,"classify":"诗人","score":60},{"id":10028,"username":"user-28","sex":"女","city":"城市-28","sign":"签名-28","experience":977,"logins":21,"wealth":75935022,"classify":"作家","score":37},{"id":10029,"username":"user-29","sex":"男","city":"城市-29","sign":"签名-29","experience":647,"logins":107,"wealth":97450636,"classify":"酱油","score":27}]}';
        echo $str;
    }
    public function ce2(){
        $str='{"code":200,"msg":"ok","count":21,"data":[{"id":2,"user_name":"\u5b59\u519b2","user_img":"22","realname":"22","sex":1,"address":null,"tel":null,"create_time":"2017-09-06 09:25:21","sign":"2323","ntegral":"0","grade":null,"full":"0","birthday":null,"balance":"0","invite":null,"license":null,"status":1},{"id":3,"user_name":"\u54c8\u54c82","user_img":"22","realname":"22","sex":1,"address":"222222","tel":"15812345678","create_time":"2017-08-23 18:03:36","sign":"11111111","ntegral":"0","grade":0,"full":"0","birthday":null,"balance":"10","invite":null,"license":null,"status":0},{"id":6,"user_name":"\u54c8\u54c822","user_img":"20170901\457e4c46df51c80471ff75bd628cc7aa.txt","realname":"22","sex":1,"address":"11","tel":"15855189107","create_time":"2017-09-01 17:14:23","sign":"1114","ntegral":"0","grade":null,"full":"0","birthday":null,"balance":"0","invite":null,"license":null,"status":0},{"id":7,"user_name":"111","user_img":"20170901\8b79c1b8da63fc6778ce7f0a9f54e38d.txt","realname":"22","sex":1,"address":"1","tel":"22","create_time":"2017-09-01 17:16:22","sign":"33","ntegral":"0","grade":null,"full":"0","birthday":null,"balance":"0","invite":null,"license":null,"status":0},{"id":8,"user_name":"112222222","user_img":"20170901\37474c64cd55cbcaae37196b0afdeaf4.txt","realname":"22","sex":2,"address":"11","tel":"15855189107","create_time":"2017-09-01 17:19:21","sign":"111","ntegral":"0","grade":null,"full":"0","birthday":null,"balance":"0","invite":null,"license":null,"status":0},{"id":9,"user_name":"112122","user_img":"20170901\0b1b287cab0ea554afa7109cd2295844.txt","realname":"22","sex":1,"address":"111","tel":"22","create_time":"2017-09-01 17:20:56","sign":"0","ntegral":"0","grade":1,"full":"0","birthday":null,"balance":"0","invite":null,"license":null,"status":0},{"id":10,"user_name":"","user_img":"2","realname":"22","sex":22,"address":null,"tel":null,"create_time":"2017-10-03 12:13:47","sign":null,"ntegral":"0","grade":null,"full":"0","birthday":null,"balance":"0","invite":null,"license":null,"status":0},{"id":11,"user_name":"","user_img":"22","realname":"22323","sex":3,"address":null,"tel":null,"create_time":"2017-10-03 12:16:16","sign":null,"ntegral":"0","grade":null,"full":"0","birthday":null,"balance":"0","invite":null,"license":null,"status":0},{"id":12,"user_name":"22","user_img":"22","realname":"22","sex":2,"address":null,"tel":null,"create_time":"2017-10-03 12:36:07","sign":null,"ntegral":"0","grade":null,"full":"0","birthday":null,"balance":"0","invite":null,"license":null,"status":0},{"id":13,"user_name":"22","user_img":"22","realname":"22","sex":232,"address":null,"tel":null,"create_time":"2017-10-03 12:37:37","sign":null,"ntegral":"0","grade":null,"full":"0","birthday":null,"balance":"0","invite":null,"license":null,"status":0}]}';
        echo $str;
    }
    public function ce3(){
        $result['code']=0;
        $result['msg']='';
        $result['data']=db('user')->select();
        return $result;
    }
}